Formula comments are notes that are included with a formula to explain its design and operation. Comments do not print, and they do not affect the formula; they appear only in the Formula Editor.
The text that follows the operator is a comment.
The following examples are applicable to Basic syntax:
Rem This formula returns the total number of days worked in a year.
Comment is on a new line on its own.
formula = TotalDays : Rem Total number of days worked in a year.
Comment follows a formula statement and a colon.
formula = TotalDays : Rem This formula returns the total number of days _
Comment follows a formula statement and a colon, and it uses the line continuation character to continue onto the next line.
The text that follows the operator is a comment.
The following examples are applicable to Basic syntax:
' This formula returns the total number of days worked in a year.
Comment is on a new line on its own.
formula = TotalDays 'Total number of days worked in a year.
Comment follows a formula statement.
formula = TotalDays 'This formula returns the total number of days _
Comment follows a formula statement, and it uses the line continuation character to continue onto the next line.
The text that follows the operator is a comment; it is not treated as part of a formula, and it does not print.
The following examples are applicable to Crystal syntax:
// calculates the gross profit
{file.SALES} - {file.COST} is the formula; the Formula Editor ignores everything else.
({file.SALES} - {file.QUOTA}) *.06
// calculates sales commission
({file.SALES} - {file.QUOTA}) * .06 is the formula; the Formula Editor ignores everything else.
//we force the line break we have
//to begin each new line with a
If {file.COST} > {file.SELL PRICE} Then "Loss" Else "";
All commented lines that appear before or after the formula are ignored.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |